[dbo].[OrderSuperProductChildProduct]

Property	Value
Created	10:31:30 AM Tuesday, March 02, 2010
Last Modified	11:40:05 AM Monday, February 20, 2012

Property

Value

Created

10:31:30 AM Tuesday, March 02, 2010

Last Modified

11:40:05 AM Monday, February 20, 2012

Name	Data Type	Max Length (Bytes)	Identity
OrderSuperProductChildProductID	int	4	1 - 1
OrderProductID	int	4
ProductCode	varchar(31)	31
DefaultForPrice	bit	1
Title	varchar(60)	60

Name

Data Type

Max Length (Bytes)

Allow Nulls

Identity

OrderSuperProductChildProductID

int

1 - 1

OrderProductID

int

ProductCode

varchar(31)

DefaultForPrice

bit

Title

varchar(60)

	Name	Columns	Unique
	PK_OrderSuperProductChildProduct	OrderSuperProductChildProductID
	iWC	ProductCode

Name

Columns

Unique

PK_OrderSuperProductChildProduct

OrderSuperProductChildProductID

iWC

ProductCode

Name	Update	Delete	Columns
FK_OrderSuperProductChildProduct_OrderProduct	Cascade	Cascade	OrderProductID->[dbo].[OrderProduct].[OrderProductID]

Name

Update

Delete

Columns

FK_OrderSuperProductChildProduct_OrderProduct

Cascade

OrderProductID->[dbo].[OrderProduct].[OrderProductID]

SQL Script

CREATE TABLE [dbo].[OrderSuperProductChildProduct]
(
[OrderSuperProductChildProductID] [int] NOT NULL IDENTITY(1, 1),
[OrderProductID] [int] NOT NULL,
[ProductCode] [varchar] (31) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[DefaultForPrice] [bit] NOT NULL,
[Title] [varchar] (60) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]

GO
ALTER TABLE [dbo].[OrderSuperProductChildProduct] ADD CONSTRAINT [PK_OrderSuperProductChildProduct] PRIMARY KEY CLUSTERED ([OrderSuperProductChildProductID]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [iWC] ON [dbo].[OrderSuperProductChildProduct] ([ProductCode]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[OrderSuperProductChildProduct] ADD CONSTRAINT [FK_OrderSuperProductChildProduct_OrderProduct] FOREIGN KEY ([OrderProductID]) REFERENCES [dbo].[OrderProduct] ([OrderProductID]) ON DELETE CASCADE ON UPDATE CASCADE
GO